package com.benedu.green.moon.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.gitee.sunchenbin.mybatis.actable.annotation.Column;
import com.gitee.sunchenbin.mybatis.actable.annotation.TableComment;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * 化石基本信息表
 */
@Data
@TableComment( "化石基本信息表")
@TableName(value = "t_fossil_reliquiae_info", autoResultMap = true)
public class FossilReliquiaeInfoEntity implements Serializable {

    @Column(comment = "主键ID",isNull = false, isKey = true)
    @TableId(value = "id_",type = IdType.ASSIGN_ID )
    private String id;

    @Column(comment = "所在行政区")
    @TableField("city_area")
    private String cityArea;

    @Column(comment = "场地名称")
    @TableField("place_name")
    private String placeName;

    @Column(comment = "产地编号",isNull = false)
    @TableField("place_number")
    private String placeNumber;

    @Column(comment = "样品编号")
    @TableField("number_")
    private String number;

    @Column(comment = "化石数量")
    @TableField("fossil_number")
    private Integer fossilNumber;

    @Column(comment = "种类")
    @TableField("category_")
    private String category;

    @Column(comment = "属中文名")
    @TableField("belong_chinese_name")
    private String belongChineseName;

    @Column(comment = "种中文名")
    @TableField("seed_chinese_name")
    private String seedChineseName;


    @Column(comment = "属阿拉名")
    @TableField("belong_allah_name")
    private String belongAllahName;

    @Column(comment = "种阿拉名")
    @TableField("seed_allah_name")
    private String seedAllahName;

    @Column(comment = "泡面层号")
    @TableField("profile_number")
    private String profileNumber;

    @Column(comment = "图片位置")
    @TableField("image_local")
    private String imageLocal;

    @Column(comment = "相对距离")
    @TableField("relatively_distance")
    private String relativelyDistance;

    @Column(comment = "相对位置")
    @TableField("relatively_location")
    private String relativelyLocation;

    @Column(comment = "样品层号")
    @TableField("specimen_number")
    private String specimenNumber;

    @Column(comment = "姓氏年号")
    @TableField("family_era_name")
    private String familyEraName;

    @Column(comment = "亚种名称")
    @TableField("subspecies_name")
    private String subspeciesName;

    @Column(comment = "入库时间")
    @TableField("put_storage_date")
    private Date putStorageDate;

    @Column(comment = "审核状态")
    @TableField("audit_status")
    private String auditStatus;

    @Column(comment = "删除状态")
    @TableField("is_delete")
    @TableLogic
    private String isDelete;

    @Column(comment = "创建时间")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField("create_time")
    private Date createTime;

    @Column(comment = "修改时间")
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @TableField("update_time")
    private Date updateTime;

    // 入库状态
    @Column(comment = "入库状态")
    @TableField("put_storage_status")
    private String putStorageStatus;
}
